Chapter 3-9: Query Processes |
Query Process Rules Option Selecting the Rules option accesses the query process frame Event Points For Rules overlay which allows you to select from a variety of options that access the ILF Editor for APPX event points. If statements were defined in the event point, the text on the overlay is highlighted. Upon completion, you are returned to the query Event Points For Rules overlay. The query Event Points overlay contains the following options: Start of Process (Query Setup) Start of Process (query setup) accesses the ILF editor for the Start of Process event point. Statements in this event point execute during query setup. Upon completion, you are returned to the query Event Points overlay. End of Process (Query Setup) End of Process (query setup) accesses the ILF editor for the End of Process event point. Statements in this event point execute during query setup. Upon completion, you are returned to the process Event Points overlay. Start of Query Execution Start of Query Execution accesses the ILF editor for the Start of Query Execution event point. Statements in this event point execute just before the query starts. Upon completion, you are returned to the query Event Points overlay. Establish PCF Range This event point provides explicit control for the designer to establish the range (or ranges) of records from the PCF file which are read by the query. This can significantly increase query performance by utilizing available key fields. Establish PCF Range This option can be coded by the designer. Otherwise, it will be generated at runtime based on any Record Selection Beg At and End At questions. To explicitly limit customer records to those for a given state, code in the Establish PCF Range event point would consist of a simple BEG AT/END AT loop. These loops can be repeated multiple times to establish multiple ranges for the query to process. Pre-User Selection Pre-User Selection accesses the ILF editor for the Pre- User Selection event point. Upon completion, you are returned to the query Event Points overlay. Post User Selection Post User Selection accesses the ILF editor for the Post User Selection event point. Upon completion, you are returned to the query Event Points overlay. End of Query Execution End of Query Execution accesses the ILF editor for the End of Query Execution event point. Statements in this event point execute when the query is finished. Upon completion, you are returned to the query Event Points overlay. PCF Level EPs PCF Level EPs provides access to the File Level Event Points for the PCF file. This overlay is shown below. These Event Points are not directly associated with the process but with the PCF file. See the Rules Option section of Files and Fields for more information on using PCF Level Event Points.
Event Points For Rules Overlay |
Application Design Manual "Powered by Appx Software"1099 ©2006 By APPX Software, Inc. All Rights Reserved |
